🕷️️ Job Radar • SCRAPING

upwork.com 2026-04-24 🟡

🔹 Extract LinkedIn URLs and Employee Range for Companies
👤 Client: 🇺🇸 United States Member since 2020-02-29
💰 Price: $20
🚩 Problem: Automate data extraction from an Excel spreadsheet containing company information.
📦 Existing: [Stack]

Specifications:

[Target] Extract LinkedIn URL, employee range, and private equity ownership status for each company.
[Method] Web scraping using Python with libraries like BeautifulSoup or Selenium.
[UI/UX] Not applicable
[Stack] Python, BeautifulSoup/Selenium, Pandas
[Security] Ensure compliance with LinkedIn API terms of service; use proxies to avoid IP blocking.
[Format] Excel

Workflow:

Install necessary libraries: pandas, selenium (or beautifulsoup4).
Load the existing Excel file into a pandas DataFrame.
Iterate through each company in the DataFrame, navigate to its LinkedIn URL using Selenium or BeautifulSoup.
Extract the employee range from the LinkedIn page and update the corresponding cell in the DataFrame.
Search for the company name plus 'private equity' on Google. Analyze top results to determine if the company is owned by a private equity firm.
If a private equity firm is identified, note it in the appropriate column of the DataFrame.
Save the updated DataFrame back into an Excel file.